﻿CREATE TABLE [dbo].[Teacher] (
    [TeacherID]            INT            IDENTITY (1, 1) NOT NULL,
    [FirstName]            NVARCHAR (255) NULL,
    [Surname]              NVARCHAR (255) NULL,
    [BirthDate]            DATE           NULL,
    [PESEL]                NVARCHAR (20)  NULL,
    [Address_Street]       NVARCHAR (255) NULL,
    [Address_City]         NVARCHAR (255) NULL,
    [Address_Municipality] NVARCHAR (255) NULL,
    [Address_PostCode]     NVARCHAR (30)  NULL,
    [CreateDate]           DATETIME       NULL,
    [UpdateDate]           DATETIME       NULL,
    [IsHeadmaster]         BIT            NULL,
    [Login]                NVARCHAR (255) NOT NULL,
    [Password]             NVARCHAR (255) NOT NULL,
    [Email]                NVARCHAR (325) NULL
);

